﻿CREATE TABLE [dbo].[Asset] (
    [AssetID]          INT           IDENTITY (1, 1) NOT NULL,
    [AssetName]        VARCHAR (100) NULL,
    [AssetTypeID]      INT           NULL,
    [SiteDepartmentID] INT           NULL,
    [UserGroupID]      INT           NULL,
    [AssetStatusID]    INT           NULL,
    [BarcodeID]        VARCHAR (250) NULL,
    [SerialNo]         VARCHAR (250) NULL,
    [ModelNo]          VARCHAR (250) NULL
);

